MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Home / Home Budget (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-01-25 | 179KB | 1,406 lines

version 106 HBAM2016AUG95 Pro 3.0 HBAM3016AUG95@ businessA business incomeA dividendsA incomeA interestA interest incomeA otherA other income other income permanentA permanent secondaryA secondary stockA stock dividendsA autoA insuranceA dentalA cleaningA cleaning suppliesA electricA electricA gasoline laundry maintenance phone sanitation suppliesA transportation water allowances bonds books collegeA college fundA fundA gifts medical savings vacation dentalY dental insuranceA healthA health insuranceA home/apartmentA home/apartment insuranceA insuranceA lifeA insuranceA mortgage otherA other insuranceA Pro 2.0 - 2.1F! Pro 3.0 Franz App HP DeskJet 540 Printer BALANCE DATE CREATED DATE MODIFIED FIXED EXP BUDGET FIXED EXP CATEGORY INCOME BUDGET INCOME CATEGORY LAST LAYOUT LIVING EXP BUDGET LIVING EXP CATEGORY MONTH MONTH ID OTHER EXP BUDGET OTHER EXP CATEGORY SUMMARY OF BALANCE SUMMARY OF FIXED EXPENSE BUDGET SUMMARY OF INCOME BUDGET 0 SUMMARY OF LIVING EXPENSE BUDGET 2 SUMMARY OF OTHER EXPENSES BUDGET TOTAL OF FIXED EXPENSE BUDGET TOTAL OF INCOME BUDGET TOTAL OF LIVING EXPENSE BUDGET TOTAL OF OTHER EXPENSES BUDGET Month IDB Income BudgetB Income CategoryB Fixed Exp CategoryB Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/20/95 Description Use this database to maintain a monthly budget an effective way to control spending and save money. Each month is one record. This solution is an example of how to use repeating fields. You could achieve the same result by using one record per entry, with many records in each month. How to use this solution Enter your monthly income in the file. Then enter: fixed expenses, such as rent, loans, and insurance essential expenses, such as food and transportation any remai ,ning income to other categories Set up a new budget every month. You'll be able to regularly examine and assess your spending and savings pattern. How to customize this solution You can modify the information in the fields for income and expenses by changing the category names and dollar amounts. Income A List View Fixed Exp BudgetB MonthB Total of Income BudgetB Total of Fixed Expense BudgetB Living Exp CategoryB Living Exp BudgetB Total of Living Expense BudgetB Other Exp CategoryB Other Exp BudgetB Total of Other Expenses BudgetB BalanceB Summary of Income BudgetB Summary of Fixed Expense BudgetB 2A Summary of Living Expense BudgetB 3A Summary of Other Expenses BudgetB Summary of BalanceB Date CreatedB Date ModifiedB InfoB Last LayoutB IncomeB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Monthly Detail Information Report Menu Fixed Expenses Living Expenses Other Expenses Monthly Summary A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Totals Balance Other Expenses Living Expenses Fixed Expenses Income Total: Category Budget Income Other Expenses Living Expenses Fixed Expenses Month Enter data for Income Monthly DetailB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Balancei Other Expensesj Living Expensesk Fixed Expensesl Incomem Monthn Your Own Buttono Your Own Buttonp Recordq Delete Recordr Records Reportst View As Listu View As Formv Closew Infox#Click to see the budget for a month Formv Closew Infox#Click to see the budget for a month InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Page ## Home Budget Monthly Detail Total Income: Income Total Other Expenses: Other Expenses Total Living Expenses: Living Expenses Total Fixed Expenses: Fixed Expenses Category Balance for Month: Account Budget Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO*Information about the Home Budget solutionP Info for this Solution on about the Home Budget solutionP Info for this Solution Your Own ReportB Your Own ReportC Monthly SummaryD Monthly DetailE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report Fixed ExpensesB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own ButtonB ReportsC View As ListD View As FormE CloseF Living ExpensesB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Buttonu Your Own Buttonv Recordw Delete Recordx Recordy Reportsz View As List{ View As Form| Close} Info~ Totals Balance Other Expenses Living Expenses Fixed Expenses Income Total: Income Other Expenses Living Expenses Fixed Expenses Month Category Budget Enter data for Fixed Expenses Other ExpensesB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Buttonu Your Own Buttonv Recordw Delete Recordx Recordy Reportsz View As List{ View As Form| Close} Info~ Totals Balance Other Expenses Living Expenses Fixed Expenses Income Income Other Expenses Living Expenses Fixed Expenses Total: Month Category Budget Enter data for Living Expenses Monthly SummaryB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button| Your Own Button} Record~ Delete Record Record Reports View As View As Close Month Total: Category Budget Totals Balance Other Expenses Living Expenses Fixed Expenses Income Enter data for Other Expenses Income Other Expenses Living Expenses Fixed Expenses Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Page ## Home Budget Monthly Summary Grand Totals: Balance Other Expenses Living Expenses Fixed Expenses Income Month Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb 1100c 1/1/95g 3055h 1390i Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundryj Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 10/1/95 Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb Your Own ButtonB ReportsC View As ListD View As FormE CloseF 16680g 36660k 3252m 16728o Information List View Report Menu New Record Sort by Month Monthly Detail Monthly Summary Open Script Sort by Month Monthly Detail New Record 1100c 2/1/95g 3055h 1390i Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundryj Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 05/11/95v 05/20/95 Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb 1100c 3/1/95g 3055h 1390i Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundryj Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 05/11/95v 05/20/95 Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb 1100c 4/1/95g 3055h 1390i Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundryj Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 05/11/95v 05/20/95 Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb 1100c 5/1/95g 3055h 1390i Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundryj Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 05/11/95v 05/20/95 Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb 1100c 6/1/95g 3055h 1390i Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundry Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 05/11/95v 05/20/95 Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb 1100c 7/1/95g 3055h 1390i Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundryj Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 05/11/95v 05/20/95 Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb 1100c 8/1/95g 3055h 1390i Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundryj Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 05/11/95v 05/20/95 Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb 1100c 9/1/95g 3055h Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundryj Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 05/11/95v 05/20/95 Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb 1100c 10/1/95g 3055h 1390i Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundryj Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 05/11/95v 05/20/95 Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb 1100c 11/1/95g 3055h 1390i Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundryj Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 05/11/95v 05/20/95 Permanent Job Secondary Job Business Income Interest Income Stock Dividends Other Income 1 Other Income 2a Auto Insurance Dental Insurance Health Insurance Home/Apartment Insurance Life Insurance Other Insurance Mortgage Rentb 1100c 12/1/95g 3055h 1390i Gas & Electric Phone Water Sanitation Gasoline Maintenance Transportation Cleaning Supplies Laundryj Savings College Fund Bonds Vacation Gifts Books Allowances Medicalm 1394o 05/11/95v 05/20/95 Monthly Summary Open Script )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E) Information dentalY A List View Report Menu Helvetica Geneva Times Times New Roman Arial MS Sans Serif wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw (LIST VDEFA( (LIST VDEFA( (LIST VDEFA( (LIST VDEFA( (LIST VDEFA( Month ListB Income ListC Fixed Expense ListD Living Expense ListE Other Expense List wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 @@BA@ JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! UUUUU (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%Q &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFG CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7 !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww UUUUUU wwwwww Information List View Report Menu New Record Sort by Month Monthly Detail Monthly Summary Open Script Sort by Month Monthly Detail New Record